IF NOT EXISTS (SELECT 1 FROM sys.columns 
			WHERE name = 'StatusDesc' 
			AND object_id = OBJECT_ID(N'[dbo].[CGO_PaymentStatus]'))
BEGIN
  ALTER TABLE dbo.CGO_PaymentStatus ADD StatusDesc NVARCHAR(100) NULL
END

UPDATE dbo.CGO_PaymentStatus
SET StatusDesc = StatusCode

UPDATE dbo.CGO_PaymentStatus
SET StatusDesc = 'Waiting to Pay'
WHERE StatusCode='WaitingForPay'

UPDATE dbo.CGO_PaymentStatus
SET StatusDesc = 'Refunded'
WHERE StatusCode = 'Refund'

UPDATE dbo.CGO_PaymentStatus
SET StatusDesc = 'Canceled'
WHERE StatusCode = 'Cancel'